-------------------- Ngay Van dung Lai suat -------------------
----------- xem thong tin ngay van dung lai suat ------------------------
if exists (select name from sysobjects where name like 'Proc_NgayVDLS_GetById')
	drop procedure Proc_NgayVDLS_GetById
go

create PROC Proc_NgayVDLS_GetById (@maNgayVDLS int )
as
	select * from NgayVDLS
	where MaNgayVDLS = @maNgayVDLS
go

Exec Proc_NgayVDLS_GetById 1
go

------------- xem thong tin ngay van dung lai suat thong qua ma nhan vien -------------
if exists (select name from sysobjects where name like 'Proc_NgayVDLS_GetByMaNV')
	drop procedure Proc_NgayVDLS_GetByMaNV
go

create PROC Proc_NgayVDLS_GetByMaNV (@maNV int )
as
	select * from NgayVDLS
	where MaNV = @maNV
go

Exec Proc_NgayVDLS_GetByMaNV 1
go